2016-06-06 - 27385 - Spec - EMEA Invoice Clean-up New Output Report #CrystalReportDevelopment
SPECIFICATIONS
27385-EMEA Invoice Clean-up/New Output Report
Purpose
Need to create new report with required fields.
Admin Info
Purpose
|
Need to create new report with required fields.
|
Requested By
|
Pierre Pazgrat
|
Spec Created By
|
Venkateswara Reddy D
|
Spec Created Date
|
06/06/2016
|
Spec QA by
|
Uday P
|
Objects
|
VBRK,VBRP,T001
|
Document Status
|
Complete
|
Estimates
SlNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
10
|
2
|
Documentation
|
10
|
3
|
Development/ Config
|
40
|
4
|
Unit test in DEV
|
00
|
5
|
Unit test in QUA
|
00
|
6
|
Other activity
|
10
|
|
TOTAL
|
70
|
References
Prior Tickets
None
Documents
AR400 Standard Checklist.xlsx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Need to add customer in the report.
|
Rizwan Shah
|
07-21-2016
|
Customer field added in the report.
|
2
|
Need to filter the data based on the created date.
|
Rizwan Shah
|
07-28-2016
|
By default created date is equal to current date -1 or input parameter.
|
3
|
Need to set the date parameter as optional.
|
Rizwan Shah
|
07-28-2016
|
Data parameter set as optional.
|
4
|
Need to add sales org as optional parameter in the report.
|
Rizwan Shah
|
08-01-2016
|
Sales org parameter added as optional parameter in the report.
|
Functional Requirement
Purpose/WHY:
Need to get the debtor number based on the Invoice number.
In Scope:
Need to create new report with required fields.
Out of Scope:
None
Solution Summary
1. Need to create parameter for invoice and filter the data with input parameter values.
2. Need to create sub report to get the debtor number.
3. Need to link between main report to sub report.
4. Need to display the required fields in the report.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
2
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Need to create parameter for invoice and filter the data with input parameter values.
2. Need to create sub report to get the debtor number.
3. Need to link between main and sub report.
4. Need to display the required fields in the report.
Issues
Performance issues were resolved by using the filter conditions for region and other conditions.
Need to create new report with required fields.